"192.168.0.1:sipop"

DETALLEREQUISICION_BI

Descriptions

There is no desription for trigger DETALLEREQUISICION_BI

Definition

CREATE TRIGGER DETALLEREQUISICION_BI FOR DETALLEREQUISICION ACTIVE
BEFORE INSERT POSITION 0
AS
declare variable AUTOINCREMENTO integer;

BEGIN
  /* Trigger body */

IF (NEW.id_detalle_req IS NULL) then
BEGIN
     AUTOINCREMENTO = GEN_ID(gen_requisicion,1);
    new.id_detalle_req=AUTOINCREMENTO;

  IF ( AUTOINCREMENTO >99999999) THEN
     EXECUTE STATEMENT 'SET GENERATOR gen_requisicion TO 0';

         NEW.ITEM_ENTREGADO = 'false';
         new.item_anulado = 'false';
  END
END

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.